PX COORDINATOR
Short Description
The PX COORDINATOR row source represents the Query Coordinator (QC) which controls and schedules the parallel plan appearing below it in the plan tree.
Detailed Description​
Partitioning is typically used on very large tables and use of the partition keys can allow targeted access to a reduced data set - remember - to make a query go faster - access less data. Partitioned tables can be accessed using parallel query servers. Parallel query servers are great at returning data fast, but be aware of the CPU and disk resource usage as in a multi user system, resources can be exhausted very quickly.
Further Reading​
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.